UPDATE SELECT 语法

单表：使用子查询

UPDATE table t1
[LEFT/RIGHT] JOIN (
  SELECT column...
  FROM table
  WHERE some_condition
) AS t2 ON t1.column = t2.column
SET t1.column = t2.column...
[WHERE some_condition]

多表：使用 JOIN 查询

UPDATE table1 t1
[LEFT/RIGHT] JOIN table2 t2 ON t1.column = t2.column
SET t1.column = t2.column...
[WHERE some_condition]